Step-5 Create Database Diagram in ColaberryResortRealtyDM Database 5

Now, we will create Database Diagram in the ColaberryResortRealtyDM Database

Now, Right Click on the Database Diagram within ColaberryResortRealtyDM Database. à Click New Database Diagram

Now, Add Table window will open. Choose all the Dimension and Fact tables that we want to add into the Database Diagram à Close the Window

Now, we will create the relationship between Dim and Fact tables.

For that we will Select & Drag the Dim_BookingAgenId( Which is a PK in the Dim_BookingAgent Table) and Drop it on to the Dim_BookingAgentid (which is a FK in the Fact_Folio Table).

Once you Do that You will see the Following in your window. Check the relationship and click OK.

Again Click OK

We can see that relationship has been created

Follow the same steps to create the relationship between Dim_Property and Fact_Folio Tables

Follow the same steps to create the relationship between Dim_Availability and Fact_Folio Tables.

And You will see all the tables with Primarykey Foreignkey relationship among the tables in the diagram. Rearrange & Connect them so, they can fit into the Window

Save the Diagram and you will see the Database diagram created

Please follow the link to see how to create the Database Diagram:

https://www.youtube.com/watch?v=N6PhiiXJMeU